package com.eascs.web.o2o.scheduler.service;

import javax.inject.Inject;

import org.springframework.stereotype.Service;
@Service
public class SendMessageService {
	
	@Inject
	O2oh5Service o2oh5Service;
	
	public void sendMessage() {
		o2oh5Service.SendMessage("SELECT apply.id, apply.uname, apply.telphone, loan_money, office.province, office.city, detail_addresss, cooperate_platform, link.telphone AS customer_manager_phone FROM applay_info apply LEFT JOIN office_info office ON apply.id = applyer_id LEFT JOIN loan_linkman link ON link.province = office.province WHERE is_send = 0");
	}

}
